What is SQL Cache Dependency in ASP.NET?
2424
25-Oct-2010
Pushpendra Singh
26-Oct-2010SQL Cache Dependency in ASP.NET: It is the mechanism where the cache object gets invalidated when the related data or the related resource is modified. It is a feature in SQL Server 2005 and SQL Server 2000.
3 types of SQL-cache dependencies exist:
a. Other cache items.
b. Files/folders.
c. Dependencies on a database query.